different results selecting from base tables or views - Mailing list pgsql-hackers

From Matthias Schmitt
Subject different results selecting from base tables or views
Date
Msg-id v04020a01b2ca3fa67abd@[192.168.129.13]
Whole thread Raw
List pgsql-hackers
I discovered different results when selecting data from base tables or
their views. The only thing I can image for this strange behaviour is using
the date constant 'today' when creating the view. Does 'today' in a view
use the current day time of the view creation or the time the query is made
?

magic moving pixel s.a.   http://www.mmp.lu


pgsql-hackers by date:

Previous
From: "Jose' Soares"
Date:
Subject: Re: [HACKERS] about RULES
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] different results selecting from base tables or views